[dbo].[BAEOrderSuperProductAttributeValueLoadForProduct]
create procedure [dbo].[BAEOrderSuperProductAttributeValueLoadForProduct] @OrderChildProductId as
int,
@OrderProductAttributeId AS int
AS
SELECT av.*
FROM OrderSuperProductAttributeValue AS av JOIN OrderSuperProductChildProductAttribute AS pa ON
av.OrderSuperProductAttributeValueID = pa.OrderSuperProductAttributeValueID
WHERE av.OrderSuperProductAttributeID = @OrderProductAttributeId AND pa.OrderSuperProductChildProductID = @OrderChildProductId;
GO
